Effective in the third maintenance release of SAS^® 9.4 (TS1M3) with hot fix A1F002, a new LIBS= (alias LIBNAMES=) option enables you to specify the libraries that should be used when you submit PROC DS2 and PROC FEDSQL commands. Prior to this option, all active libraries were used to build connection strings. Only those librefs that are named in this option are loaded from the available active libraries. In the absence of this option, all active LIBNAME statements are loaded. Any libref in the option that does not match a defined LIBNAME statement is ignored. The Work library is implicitly included as the first library in all lists, and it is the default library for data references that do not include a libref.

The syntax for the option follows:

    *  LIBS = 
    *  LIBS = (  ...  )
    *  LIBNAMES =   
    *  LIBNAMES = (  ...  )

When the MSGLEVEL=I system option is specified, messages are written to the SAS^® log indicating which LIBNAME is included or ignored based on the use of the LIBS= option.

Click the Full Code tab to see sample code that illustrates the LIBS= option.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

options msglevel=i;

libname base '.';

proc ds2 libs=(base junk1 junk2);
quit;

/* These messages are written to the SAS log */

3 proc ds2 libs=(base junk1 junk2); 
NOTE: DS2 Using libname BASE (engine V9) 
NOTE: DS2 Ignoring libname SASHELP (engine V9); not in LIBS= 
NOTE: DS2 Ignoring libname MAPS (engine V9); not in LIBS= 
NOTE: DS2 Ignoring libname MAPSGFK (engine V9); not in LIBS= 
NOTE: DS2 Ignoring libname SASUSER (engine V9); not in LIBS= 
NOTE: DS2 Using libname WORK (engine V9) 
WARNING: No match for these libnames: JUNK1 JUNK2
NOTE: Connection string:
NOTE: DRIVER=DS2;CONOPTS= (DRIVER=FEDSQL;CONOPTS= ( (DRIVER=BASE;CATALOG=BASE;SCHEMA= 
                       (NAME=BASE;PRIMARYPATH={C:\Users\myuserid})); (DRIVER=BASE;CATALOG=WORK;SCHEMA=
                       (NAME=WORK;PRIMARYPATH={C:\Users\myuserid\AppData\Local\Temp\SAS Temporary 
                        Files\_TD8380_D11111_})))) 
NOTE: Writing HTML Body file: sashtml.htm 
4 quit;

A fix for this issue for SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M1 is available at: